package tech.aistar.wyymusicplayer.mapper;

import org.apache.ibatis.annotations.Select;
import tech.aistar.wyymusicplayer.pojo.Playlist;
import tech.aistar.wyymusicplayer.pojo.PlaylistVo;

import java.util.List;

public interface PlaylistMapper {
    @Select("select * from playlist")
    List<Playlist> FindAll();

    @Select("select image_url,title,name from playlist where language_type='华语'")
    List<PlaylistVo> FindByChinese();

    @Select("select image_url,title,name from playlist where language_type='英语'")
    List<PlaylistVo> FindByEnglish();

    @Select("select image_url,title,name from playlist where language_type='韩语'")
    List<PlaylistVo> FindByKorean();

    @Select("select image_url,title,name from playlist where language_type='日语'")
    List<PlaylistVo> FindByJapanese();
}
